/*
 Navicat MySQL Data Transfer

 Source Server         : local
 Source Server Version : 50717
 Source Host           : localhost
 Source Database       : elevator_test

 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 03/22/2018 01:03:38 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `information_type`
-- ----------------------------
DROP TABLE IF EXISTS `information_type`;
CREATE TABLE `information_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type_desc` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `type_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
--  Records of `information_type`
-- ----------------------------
BEGIN;
INSERT INTO `information_type` VALUES ('1', '行业资讯', '行业资讯'), ('2', '法律法规', '法律法规'), ('3', '工作资讯', '工作资讯');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
